import openpyxl
import copy
def load_filter_config(excel_path,config_sheet_name='Sheet1'):
    wb = openpyxl.load_workbook(excel_path)
    ws = wb[config_sheet_name]
    config_list = []
    image_path_list = []
    result = []
    for row in range(2,ws.max_row+1):
        temp_dist = {
            'image_path':"",
            'solve_method':"",
            'image_explain':""
        }
        temp_dist['image_path'] = f"{ws.cell(row, 1).value}\\{ws.cell(row, 2).value}";
        temp_dist['solve_method'] = f"{ws.cell(row,3).value}"
        temp_dist['image_explain'] = f"{ws.cell(row,4).value}"
        config_list.append(temp_dist.copy())
        image_path_list.append(temp_dist['image_path'])

    result = [copy.deepcopy(config_list),image_path_list.copy()]
    return result
if __name__ == "__main__":
    print(load_filter_config(r"E:\AI\HUAWEI_SWITCH\chm\icon_replace.xlsx"))